Skip to main content

Table lock

Short Description

Table level lock

Detailed Description​

MySQL uses table level locking for MyISAM, memory and merge tables. This allows access by only one session, making them more suitable for a read-only or single user application.

For information about table lock indicators, see Section 8.11.1, “Internal Locking Methods”.

How to reduce this wait​

Not available yet. Contributions welcome.

MySQL Docs - Internal Locking Metods

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.